Georgia and Florida Reopening Among COVID-19 Concerns¶

Applied Data Science Capstone by IBM/Coursera¶

Introduction/Business Problem¶

There are cities like Jacksonville reopening beaches while Georgia is planning to reopen several businesses starting April 24th. Is this a good time to consider reopening with the risk to public health from COVID-19 or will there be too much economic damage if not? In order to answer the questions, I will take a look at county health population information from https://www.countyhealthrankings.org/ and business information(leveraging Foursquare API)in Jacksonsville, Florida and compare to Savannah, Georgia since they are large cities located in the neighboring states. The governers of Georgia and Florida should take these factors into consideration before opening their states among COVID-19.

Data¶

I. Neighborhood Locations
I will be using http://www.city-data.com to get neighborhoods and geographical locations.

II. Foursquare Location API
I will explore business information such as number and type of businesses to see the type of impact closing the cities will have. I also want to see if there are nearby clinics, hospitals, and/or pharmacies to learn about capacity for handling rise in cases for decision in reopening.

III. County Health Rankings
I will be using county health rankings to get details about the population using information such as:

  • Quality of Life
  • Health Behaviors
  • Clinical Care
  • Social & Economic Factors

IV. Death Rates by Age
I will be using https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/ to get death rates by age.

V. Hospital Capacities
I will be using https://coronavirus.jhu.edu/us-map to get deaths, confirmed cases, and hospital capacity by county.

Methodology¶

I. Access Foursquare API
In order to determine number and/or type of businesses affected, we need to explore Jacksonville and Savannah counties. We will access the Foursquare API to get business information but first need to find all the nearby neighborhoods with geographical coordinates in each city.

Import necessary packages and libraries.

In [1]:
import numpy as np # library to handle data in a vectorized manner

import pandas as pd # library for data analsysis
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)

import json # library to handle JSON files

!conda install -c conda-forge geopy --yes # uncomment this line if you haven't completed the Foursquare API lab
from geopy.geocoders import Nominatim # convert an address into latitude and longitude values

import requests # library to handle requests
from pandas.io.json import json_normalize # tranform JSON file into a pandas dataframe

# Matplotlib and associated plotting modules
import matplotlib.cm as cm
import matplotlib.colors as colors

# import k-means from clustering stage
from sklearn.cluster import KMeans

print('Libraries imported.')
In [2]:
conda update -n base conda
In [3]:
# conda install -c anaconda beautifulsoup4
In [4]:
import requests
from bs4 import BeautifulSoup
from requests import get
from requests.exceptions import RequestException
from contextlib import closing
import re

Generate credentials to access API.

In [5]:
CLIENT_ID = 'KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA' # your Foursquare ID
CLIENT_SECRET = '01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW' # your Foursquare Secret
VERSION = '20180604'
LIMIT = 30
print('Your credentails:')
print('CLIENT_ID: ' + CLIENT_ID)
print('CLIENT_SECRET:' + CLIENT_SECRET)
Your credentails:
CLIENT_ID: KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA
CLIENT_SECRET:01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW

Create function for getting neighborhood coordinates by city. The function webscrapes city-data.com to get neighborhood information by city.

In [6]:
def get_neigborhood(URL,city):
#     URL = 'http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
    page = requests.get(URL)
    soup = BeautifulSoup(page.content, 'html.parser') 
    city_name = [tag.text for tag in soup.find_all('a',href=re.compile(r'#N\d+'))] 
    string=(','+ city)
    city_names=[x + string for x in city_name]
    column_names = ['Neighborhood', 'Latitude', 'Longitude'] 
    # instantiate the dataframe
    neighborhoods = pd.DataFrame(columns=column_names)
    #apply Nominatim
    geolocator = Nominatim(user_agent="to_explorer")
 
    for i in city_names:
        try:
            location = geolocator.geocode(i)
            latitude = location.latitude 
            longitude = location.longitude 
            neighborhoods = neighborhoods.append({'Neighborhood': i,
                                          'Latitude': latitude,
                                          'Longitude': longitude}, ignore_index=True)  
        except AttributeError:
            continue 

    # making separate first name column from new data frame 
    new = neighborhoods["Neighborhood"].str.split(",", n = 1, expand = True) 
    neighborhoods["Neighborhood"]= new[0] 
  
    # making separate last name column from new data frame 
    neighborhoods["City"]= new[1] 
    neighborhoods2 = neighborhoods[["City", "Neighborhood", "Latitude","Longitude"]]


    return neighborhoods2

Call function by city to get all neighborhoods, latitude,and longitude.
Let's start with Savannah.

In [7]:
Jacksonville='http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html'
Savannah='http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
neighborhoods=get_neigborhood(Jacksonville,city='Jacksonville')
# neighborhoods=get_neigborhood(Savannah,city='Savannah')
# 'http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html',city='Jacksonville'
In [19]:
neighborhoods.head()
Out[19]:
City Neighborhood Latitude Longitude
0 Savannah Avalon 32.050010 -81.066843
1 Savannah Avondale 32.052988 -81.057612
2 Savannah Baldwin Park 32.050870 -81.091097
3 Savannah Bartow 32.086596 -81.124556
4 Savannah Bayview 30.224534 -85.682356

Next Jacksonville neighborhoods and coordinates.

In [8]:
neighborhoods.head()
Out[8]:
City Neighborhood Latitude Longitude
0 Jacksonville Arlington 30.335795 -81.602871
1 Jacksonville Avondale 30.304406 -81.711209
2 Jacksonville Belfort Station 30.251119 -81.584455
3 Jacksonville Brooklyn 30.323573 -81.674541
4 Jacksonville Church District 30.280525 -81.490998

Use function to get nearby venues.

In [10]:
def getNearbyVenues(names, latitudes, longitudes, radius=1000):
    
    venues_list=[]
    for name, lat, lng in zip(names, latitudes, longitudes):
        print(name)
            
        # create the API request URL
        url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}&limit={}'.format(
            CLIENT_ID, 
            CLIENT_SECRET, 
            VERSION, 
            lat, 
            lng, 
            radius, 
            LIMIT)
            
        # make the GET request
        results = requests.get(url).json()["response"]['groups'][0]['items']
        
        # return only relevant information for each nearby venue
        venues_list.append([(
            name, 
            lat, 
            lng, 
            v['venue']['name'], 
            v['venue']['location']['lat'], 
            v['venue']['location']['lng'],  
            v['venue']['categories'][0]['name']) for v in results])

    nearby_venues = pd.DataFrame([item for venue_list in venues_list for item in venue_list])
    nearby_venues.columns = ['Neighborhood', 
                  'Neighborhood Latitude', 
                  'Neighborhood Longitude', 
                  'Venue', 
                  'Venue Latitude', 
                  'Venue Longitude', 
                  'Venue Category']
    
    return(nearby_venues)

Create simple variable to assign different cities.

In [22]:
A='Savannah'
In [28]:
A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
                                   latitudes=neighborhoods['Latitude'],
                                   longitudes=neighborhoods['Longitude']
                                  )
In [27]:
A_venues.head()
Out[27]:
Neighborhood Neighborhood Latitude Neighborhood Longitude Venue Venue Latitude Venue Longitude Venue Category
0 Avalon 32.05001 -81.066843 GameStop 32.044100 -81.068130 Video Game Store
1 Avalon 32.05001 -81.066843 Whole Foods Market 32.043391 -81.071361 Grocery Store
2 Avalon 32.05001 -81.066843 Hop Xing 32.044566 -81.067693 Chinese Restaurant
3 Avalon 32.05001 -81.066843 Firehouse Subs 32.041880 -81.066176 Sandwich Place
4 Avalon 32.05001 -81.066843 Sisters Of The New South 32.042652 -81.063602 Restaurant
In [11]:
A='Jacksonville'
A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
                                   latitudes=neighborhoods['Latitude'],
                                   longitudes=neighborhoods['Longitude']
                                  )
Arlington
Avondale
Belfort Station
Brooklyn
Church District
Downtown
East Jacksonville
Empire Point
Mandarin
North Jacksonville
Oakland
Ortega
River Park
Riverside
San Marco
Sherwood Forest
South Jacksonville
South Side
Springfield
Stadium District
Waterleaf
West Jacksonville
In [11]:
A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))
There are 193 uniques categories.
In [12]:
A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))
There are 140 uniques categories.

One-hot Encoding for Generating Venue Frequency

In [13]:
# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")

# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood'] 

# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]

A_onehot.head()
Out[13]:
Neighborhood ATM American Restaurant Arcade Art Gallery Art Museum Arts & Crafts Store Asian Restaurant Athletics & Sports Auto Workshop Automotive Shop Bagel Shop Bakery Bank Bar Baseball Field Baseball Stadium Basketball Stadium Beer Garden Boat or Ferry Breakfast Spot Brewery Bridal Shop Burger Joint Burrito Place Business Service Cafeteria Café Caribbean Restaurant Chinese Restaurant Cocktail Bar Coffee Shop Comfort Food Restaurant Concert Hall Construction & Landscaping Convenience Store Cosmetics Shop Deli / Bodega Dentist's Office Dessert Shop Diner Disc Golf Discount Store Dive Bar Doctor's Office Dog Run Donut Shop Electronics Store Exhibit Fast Food Restaurant Food Truck French Restaurant Fried Chicken Joint Frozen Yogurt Shop Gaming Cafe Garden Center Gas Station Gay Bar General Entertainment Gift Shop Golf Course Grocery Store Gym Gym / Fitness Center Harbor / Marina Health & Beauty Service Heliport Historic Site History Museum Home Service Hookah Bar Hot Dog Joint Hotel Hotel Pool IT Services Ice Cream Shop Indie Movie Theater Intersection Italian Restaurant Japanese Restaurant Jewelry Store Juice Bar Lawyer Light Rail Station Liquor Store Lounge Mediterranean Restaurant Mexican Restaurant Miscellaneous Shop Movie Theater Music Venue New American Restaurant Nightclub Other Great Outdoors Outdoors & Recreation Park Pet Store Pharmacy Photography Studio Pizza Place Playground Plaza Pool Pub Record Shop Rental Car Location Resort Rest Area Restaurant Salon / Barbershop Sandwich Place Shipping Store Shop & Service Shopping Mall Smoke Shop Smoothie Shop Soccer Field Soccer Stadium Spa Speakeasy Sporting Goods Shop Sports Bar Stadium Steakhouse Supplement Shop Sushi Restaurant Taco Place Tanning Salon Tea Room Tennis Court Tex-Mex Restaurant Thai Restaurant Theater Thrift / Vintage Store Trail Train Station Video Store Vietnamese Restaurant Volleyball Court Wings Joint Zoo
0 Arlington 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 Arlington 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 Arlington 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 Arlington 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 Arlington 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0
In [30]:
# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")

# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood'] 

# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]

A_onehot.head()
Out[30]:
Yoga Studio ATM Accessories Store American Restaurant Antique Shop Arcade Art Gallery Arts & Crafts Store Asian Restaurant Australian Restaurant Auto Workshop Automotive Shop BBQ Joint Bagel Shop Bakery Bank Bar Baseball Field Baseball Stadium Bed & Breakfast Beer Store Big Box Store Bike Rental / Bike Share Bistro Boat or Ferry Bookstore Boutique Bowling Alley Breakfast Spot Brewery Bubble Tea Shop Building Burger Joint Burrito Place Bus Station Business Service Café Campground Candy Store Caribbean Restaurant Chinese Restaurant Clothing Store Cocktail Bar Coffee Shop College Arts Building Construction & Landscaping Convenience Store Cosmetics Shop Cuban Restaurant Cupcake Shop Dance Studio Deli / Bodega Department Store Dessert Shop Diner Discount Store Dive Bar Dog Run Donut Shop Drive-in Theater Electronics Store Farm Farmers Market Fast Food Restaurant Food Food & Drink Shop Food Truck Fountain French Restaurant Fried Chicken Joint Frozen Yogurt Shop Furniture / Home Store Gaming Cafe Garden Gas Station General Entertainment General Travel Gift Shop Golf Course Gourmet Shop Greek Restaurant Grocery Store Gun Range Gym Gym / Fitness Center Gymnastics Gym Harbor / Marina Hardware Store Health & Beauty Service Historic Site History Museum Hobby Shop Home Service Hospital Hotel Hotel Bar Hotpot Restaurant IT Services Ice Cream Shop Indian Restaurant Intersection Italian Restaurant Japanese Restaurant Jewelry Store Kids Store Kitchen Supply Store Korean Restaurant Lake Latin American Restaurant Laundry Service Lawyer Lingerie Store Liquor Store Locksmith Lounge Market Martial Arts Dojo Massage Studio Medical Center Mediterranean Restaurant Men's Store Metro Station Mexican Restaurant Middle Eastern Restaurant Mobile Phone Shop Moving Target Multiplex Museum Neighborhood New American Restaurant Nightclub Noodle House Optical Shop Outdoors & Recreation Outlet Mall Paper / Office Supplies Store Park Persian Restaurant Pet Store Pharmacy Photography Studio Pie Shop Pizza Place Playground Plaza Pool Pub Record Shop Rental Car Location Restaurant River Road Salon / Barbershop Sandwich Place Scenic Lookout Seafood Restaurant Shipping Store Shoe Store Shopping Mall Shopping Plaza Skating Rink Smoothie Shop Soccer Field Soccer Stadium Southern / Soul Food Restaurant Spa Sporting Goods Shop Sports Bar Storage Facility Supermarket Supplement Shop Sushi Restaurant Taco Place Tailor Shop Tanning Salon Tea Room Tennis Court Thai Restaurant Theater Thrift / Vintage Store Tour Provider Tourist Information Center Track Vegetarian / Vegan Restaurant Video Game Store Video Store Vietnamese Restaurant Vineyard Whisky Bar Wine Bar Winery Wings Joint Women's Store
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avalon 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avalon 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avalon 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avalon 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avalon 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
In [31]:
#Savannah
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()
Out[31]:
Neighborhood Yoga Studio ATM Accessories Store American Restaurant Antique Shop Arcade Art Gallery Arts & Crafts Store Asian Restaurant Australian Restaurant Auto Workshop Automotive Shop BBQ Joint Bagel Shop Bakery Bank Bar Baseball Field Baseball Stadium Bed & Breakfast Beer Store Big Box Store Bike Rental / Bike Share Bistro Boat or Ferry Bookstore Boutique Bowling Alley Breakfast Spot Brewery Bubble Tea Shop Building Burger Joint Burrito Place Bus Station Business Service Café Campground Candy Store Caribbean Restaurant Chinese Restaurant Clothing Store Cocktail Bar Coffee Shop College Arts Building Construction & Landscaping Convenience Store Cosmetics Shop Cuban Restaurant Cupcake Shop Dance Studio Deli / Bodega Department Store Dessert Shop Diner Discount Store Dive Bar Dog Run Donut Shop Drive-in Theater Electronics Store Farm Farmers Market Fast Food Restaurant Food Food & Drink Shop Food Truck Fountain French Restaurant Fried Chicken Joint Frozen Yogurt Shop Furniture / Home Store Gaming Cafe Garden Gas Station General Entertainment General Travel Gift Shop Golf Course Gourmet Shop Greek Restaurant Grocery Store Gun Range Gym Gym / Fitness Center Gymnastics Gym Harbor / Marina Hardware Store Health & Beauty Service Historic Site History Museum Hobby Shop Home Service Hospital Hotel Hotel Bar Hotpot Restaurant IT Services Ice Cream Shop Indian Restaurant Intersection Italian Restaurant Japanese Restaurant Jewelry Store Kids Store Kitchen Supply Store Korean Restaurant Lake Latin American Restaurant Laundry Service Lawyer Lingerie Store Liquor Store Locksmith Lounge Market Martial Arts Dojo Massage Studio Medical Center Mediterranean Restaurant Men's Store Metro Station Mexican Restaurant Middle Eastern Restaurant Mobile Phone Shop Moving Target Multiplex Museum New American Restaurant Nightclub Noodle House Optical Shop Outdoors & Recreation Outlet Mall Paper / Office Supplies Store Park Persian Restaurant Pet Store Pharmacy Photography Studio Pie Shop Pizza Place Playground Plaza Pool Pub Record Shop Rental Car Location Restaurant River Road Salon / Barbershop Sandwich Place Scenic Lookout Seafood Restaurant Shipping Store Shoe Store Shopping Mall Shopping Plaza Skating Rink Smoothie Shop Soccer Field Soccer Stadium Southern / Soul Food Restaurant Spa Sporting Goods Shop Sports Bar Storage Facility Supermarket Supplement Shop Sushi Restaurant Taco Place Tailor Shop Tanning Salon Tea Room Tennis Court Thai Restaurant Theater Thrift / Vintage Store Tour Provider Tourist Information Center Track Vegetarian / Vegan Restaurant Video Game Store Video Store Vietnamese Restaurant Vineyard Whisky Bar Wine Bar Winery Wings Joint Women's Store
0 Avalon 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.066667 0.0 0.0 0.000000 0.0 0.00 0.000000 0.000000 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.033333 0.000000 0.0 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.00 0.0 0.0 0.000000 0.000000 0.0 0.0 0.033333 0.033333 0.0 0.0 0.033333 0.0 0.0 0.033333 0.0 0.000000 0.0 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.066667 0.000000 0.066667 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.033333 0.033333 0.0 0.0 0.066667 0.000000 0.000000 0.000000 0.000000 0.0 0.033333 0.033333 0.0 0.0 0.000000 0.066667 0.0 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.033333 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Avondale 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.00 0.071429 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.071429 0.142857 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.071429 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.071429 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.071429 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.071429 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.142857 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.071429 0.0 0.0 0.0 0.0 0.071429 0.0 0.0 0.0 0.000000 0.0 0.071429 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.071429 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2 Baldwin Park 0.0 0.0 0.0 0.066667 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.033333 0.0 0.0 0.0 0.000000 0.0 0.0 0.033333 0.0 0.00 0.000000 0.033333 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.00 0.1 0.0 0.000000 0.033333 0.0 0.0 0.033333 0.000000 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.066667 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.033333 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.100000 0.0 0.033333 0.000000 0.0 0.0 0.000000 0.066667 0.033333 0.033333 0.033333 0.0 0.000000 0.033333 0.0 0.0 0.033333 0.000000 0.0 0.033333 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.066667 0.0 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
3 Bartow 0.0 0.0 0.0 0.100000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.100000 0.0 0.0 0.000000 0.0 0.00 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.200000 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.100000 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.100000 0.0 0.200000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.100000 0.1 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
4 Bayview 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.25 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.25 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.25 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.25 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
In [14]:
#Jacksonville
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()
Out[14]:
Neighborhood ATM American Restaurant Arcade Art Gallery Art Museum Arts & Crafts Store Asian Restaurant Athletics & Sports Auto Workshop Automotive Shop Bagel Shop Bakery Bank Bar Baseball Field Baseball Stadium Basketball Stadium Beer Garden Boat or Ferry Breakfast Spot Brewery Bridal Shop Burger Joint Burrito Place Business Service Cafeteria Café Caribbean Restaurant Chinese Restaurant Cocktail Bar Coffee Shop Comfort Food Restaurant Concert Hall Construction & Landscaping Convenience Store Cosmetics Shop Deli / Bodega Dentist's Office Dessert Shop Diner Disc Golf Discount Store Dive Bar Doctor's Office Dog Run Donut Shop Electronics Store Exhibit Fast Food Restaurant Food Truck French Restaurant Fried Chicken Joint Frozen Yogurt Shop Gaming Cafe Garden Center Gas Station Gay Bar General Entertainment Gift Shop Golf Course Grocery Store Gym Gym / Fitness Center Harbor / Marina Health & Beauty Service Heliport Historic Site History Museum Home Service Hookah Bar Hot Dog Joint Hotel Hotel Pool IT Services Ice Cream Shop Indie Movie Theater Intersection Italian Restaurant Japanese Restaurant Jewelry Store Juice Bar Lawyer Light Rail Station Liquor Store Lounge Mediterranean Restaurant Mexican Restaurant Miscellaneous Shop Movie Theater Music Venue New American Restaurant Nightclub Other Great Outdoors Outdoors & Recreation Park Pet Store Pharmacy Photography Studio Pizza Place Playground Plaza Pool Pub Record Shop Rental Car Location Resort Rest Area Restaurant Salon / Barbershop Sandwich Place Shipping Store Shop & Service Shopping Mall Smoke Shop Smoothie Shop Soccer Field Soccer Stadium Spa Speakeasy Sporting Goods Shop Sports Bar Stadium Steakhouse Supplement Shop Sushi Restaurant Taco Place Tanning Salon Tea Room Tennis Court Tex-Mex Restaurant Thai Restaurant Theater Thrift / Vintage Store Trail Train Station Video Store Vietnamese Restaurant Volleyball Court Wings Joint Zoo
0 Arlington 0.043478 0.043478 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.043478 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.043478 0.000000 0.000000 0.00 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.043478 0.000000 0.0 0.000000 0.000000 0.043478 0.0 0.000000 0.00 0.000000 0.0 0.0 0.043478 0.0 0.000000 0.0 0.043478 0.0 0.0 0.0 0.0 0.000000 0.043478 0.0 0.000000 0.000000 0.043478 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.043478 0.000000 0.000000 0.000000 0.0 0.000000 0.043478 0.0 0.000000 0.000000 0.043478 0.00 0.0 0.000000 0.043478 0.000000 0.000000 0.0 0.0 0.0 0.00 0.0 0.000000 0.043478 0.0 0.0 0.043478 0.000000 0.043478 0.0 0.0 0.000000 0.0 0.00 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.043478 0.00 0.043478 0.00 0.00 0.043478 0.000000 0.000000 0.0 0.0 0.00 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.0 0.043478 0.0 0.0 0.086957 0.00 0.0 0.000000 0.0
1 Avondale 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.041667 0.000000 0.041667 0.0 0.0 0.0 0.0 0.000000 0.041667 0.041667 0.00 0.000000 0.000000 0.0 0.0 0.0 0.0 0.041667 0.000000 0.041667 0.0 0.000000 0.000000 0.041667 0.0 0.041667 0.00 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.041667 0.000000 0.0 0.041667 0.041667 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.041667 0.0 0.041667 0.000000 0.0 0.000000 0.000000 0.000000 0.00 0.0 0.000000 0.000000 0.000000 0.041667 0.0 0.0 0.0 0.00 0.0 0.000000 0.041667 0.0 0.0 0.000000 0.041667 0.000000 0.0 0.0 0.041667 0.0 0.00 0.0 0.083333 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.041667 0.00 0.000000 0.00 0.00 0.000000 0.083333 0.000000 0.0 0.0 0.00 0.0 0.0 0.041667 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.0 0.000000 0.0 0.0 0.000000 0.00 0.0 0.041667 0.0
2 Belfort Station 0.000000 0.000000 0.055556 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.055556 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00 0.000000 0.000000 0.0 0.0 0.0 0.0 0.055556 0.055556 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.00 0.000000 0.0 0.0 0.000000 0.0 0.055556 0.0 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.055556 0.000000 0.0 0.0 0.0 0.000000 0.055556 0.055556 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.111111 0.055556 0.111111 0.00 0.0 0.000000 0.055556 0.055556 0.000000 0.0 0.0 0.0 0.00 0.0 0.000000 0.055556 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.00 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.00 0.111111 0.00 0.00 0.000000 0.000000 0.000000 0.0 0.0 0.00 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.0 0.000000 0.0 0.0 0.000000 0.00 0.0 0.000000 0.0
3 Brooklyn 0.000000 0.000000 0.000000 0.0 0.033333 0.033333 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00 0.033333 0.033333 0.0 0.0 0.1 0.0 0.000000 0.000000 0.000000 0.0 0.033333 0.033333 0.000000 0.0 0.066667 0.00 0.033333 0.0 0.0 0.000000 0.0 0.033333 0.0 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.033333 0.0 0.0 0.0 0.033333 0.033333 0.033333 0.000000 0.033333 0.033333 0.033333 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.00 0.0 0.033333 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.00 0.0 0.033333 0.033333 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.066667 0.0 0.00 0.0 0.000000 0.033333 0.033333 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.00 0.033333 0.00 0.00 0.000000 0.000000 0.033333 0.0 0.0 0.00 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.0 0.033333 0.0 0.0 0.000000 0.00 0.0 0.000000 0.0
4 Church District 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.040000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.04 0.000000 0.000000 0.0 0.0 0.0 0.0 0.040000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.04 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.080000 0.040000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.04 0.0 0.040000 0.000000 0.080000 0.000000 0.0 0.0 0.0 0.04 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.04 0.0 0.080000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.040000 0.08 0.040000 0.04 0.04 0.040000 0.000000 0.000000 0.0 0.0 0.04 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.04 0.0 0.000000 0.0 0.0 0.000000 0.04 0.0 0.000000 0.0

Savannah Venue Frequency¶

In [34]:
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.

For output go to Savannah_Venue

Jacksonville Venue Frequency¶

In [16]:
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.

For output go to Jacksonville_Venue

Get most common revenues and place in dataframe.

In [39]:
def return_most_common_venues(row, num_top_venues):
    row_categories = row.iloc[1:]
    row_categories_sorted = row_categories.sort_values(ascending=False)
    
    return row_categories_sorted.index.values[0:num_top_venues]

Savannah Top 10 Revenues

In [40]:
num_top_venues = 10

indicators = ['st', 'nd', 'rd']

# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
    try:
        columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
    except:
        columns.append('{}th Most Common Venue'.format(ind+1))

# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']

for ind in np.arange(A_grouped.shape[0]):
    A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)

A_neighborhoods_venues_sorted.head(10)
Out[40]:
Neighborhood 1st Most Common Venue 2nd Most Common Venue 3rd Most Common Venue 4th Most Common Venue 5th Most Common Venue 6th Most Common Venue 7th Most Common Venue 8th Most Common Venue 9th Most Common Venue 10th Most Common Venue
0 Avalon Mobile Phone Shop Pizza Place Chinese Restaurant Mexican Restaurant Sandwich Place Hardware Store Fried Chicken Joint Breakfast Spot Fast Food Restaurant Rental Car Location
1 Avondale Park Food Sporting Goods Shop Tour Provider Seafood Restaurant Fast Food Restaurant Skating Rink Liquor Store General Travel Convenience Store
2 Baldwin Park Gas Station Park Intersection Playground Southern / Soul Food Restaurant American Restaurant Seafood Restaurant Restaurant Salon / Barbershop Sporting Goods Shop
3 Bartow Pet Store Discount Store Grocery Store Seafood Restaurant American Restaurant Park Chinese Restaurant Shipping Store Food & Drink Shop Food
4 Bayview Construction & Landscaping Garden Kids Store Drive-in Theater Women's Store Electronics Store French Restaurant Fountain Food Truck Food & Drink Shop
5 Beach Institute Plaza Park Bed & Breakfast Hotel Bar Tea Room Hotel Italian Restaurant Fountain Farmers Market Dive Bar
6 Berkshire Woods Park Home Service Photography Studio Coffee Shop Women's Store Drive-in Theater Fountain Food Truck Food & Drink Shop Food
7 Bingville Convenience Store Park Discount Store Mexican Restaurant Electronics Store Bar Fast Food Restaurant Bistro Chinese Restaurant Grocery Store
8 Blueberry Hill Farm Women's Store Wings Joint Fried Chicken Joint French Restaurant Fountain Food Truck Food & Drink Shop Food Fast Food Restaurant
9 Brookview Chinese Restaurant Intersection Construction & Landscaping Furniture / Home Store Food & Drink Shop Food Golf Course Thrift / Vintage Store Southern / Soul Food Restaurant Farm

Jacksonville Top 10 Revenues

In [18]:
#Jacksonville
num_top_venues = 10

indicators = ['st', 'nd', 'rd']

# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
    try:
        columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
    except:
        columns.append('{}th Most Common Venue'.format(ind+1))

# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']

for ind in np.arange(A_grouped.shape[0]):
    A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)

A_neighborhoods_venues_sorted.head(10)
Out[18]:
Neighborhood 1st Most Common Venue 2nd Most Common Venue 3rd Most Common Venue 4th Most Common Venue 5th Most Common Venue 6th Most Common Venue 7th Most Common Venue 8th Most Common Venue 9th Most Common Venue 10th Most Common Venue
0 Arlington Video Store Restaurant ATM Italian Restaurant Mexican Restaurant Shopping Mall Seafood Restaurant Sandwich Place Fried Chicken Joint Bookstore
1 Avondale Park Pizza Place Convenience Store Gaming Cafe Plaza Deli / Bodega New American Restaurant Coffee Shop Chinese Restaurant Smoke Shop
2 Belfort Station Hotel Sandwich Place Automotive Shop Cocktail Bar Chinese Restaurant Food Truck Gas Station Japanese Restaurant Italian Restaurant Mexican Restaurant
3 Brooklyn Café Park Deli / Bodega Gym / Fitness Center Gym Smoothie Shop Sandwich Place Concert Hall Plaza Playground
4 Church District Grocery Store Pizza Place Japanese Restaurant Intersection Spa Shopping Mall Pharmacy Liquor Store Shipping Store Sandwich Place
5 Downtown Bakery History Museum Truck Stop Gas Station Bar Italian Restaurant Greek Restaurant Rest Area American Restaurant Dive Bar
6 East Jacksonville Fast Food Restaurant Video Store Light Rail Station Train Station Sandwich Place Bakery Zoo Event Service Flea Market Farmers Market
7 Empire Point Chiropractor Lawyer American Restaurant Rental Car Location Gas Station Baseball Field Donut Shop Flea Market Fast Food Restaurant Farmers Market
8 Mandarin Event Service Pet Store Business Service Farmers Market Park Food Truck Flea Market Fast Food Restaurant Exhibit Zoo
9 North Jacksonville Fast Food Restaurant Video Store Light Rail Station Train Station Sandwich Place Bakery Zoo Event Service Flea Market Farmers Market

Read CSV Files with Table Information

In [1]:
pip install xlrd
Collecting xlrd
  Downloading xlrd-1.2.0-py2.py3-none-any.whl (103 kB)
     |████████████████████████████████| 103 kB 3.6 MB/s eta 0:00:01
Installing collected packages: xlrd
Successfully installed xlrd-1.2.0
Note: you may need to restart the kernel to use updated packages.
In [2]:
pwd
Out[2]:
'/home/jovyan/demo'
In [4]:
import pandas as pd
County_Table= pd.read_csv('/home/jovyan/demo/County_Health_Rankings.csv')
In [16]:
County_Table[County_Table.isnull()]=""
County_Table.head()
Out[16]:
Unnamed: 0 Duval (DU) , FL Chatham (CA) , GA
0 Demographics
1 Population 950,181 289,195
2 % below 18 years of age 22.60% 21.20%
3 % 65 and older 14.00% 15.40%
4 % Non-Hispanic Black 29.50% 40.10%

Import Death by Age Table
Reference:https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/
As of May 13th

In [ ]:
Death_by_Age_Table= pd.read_csv('/home/jovyan/demo/Death_By_Age_Coronavirus.csv')

Import Fatalaties and Hospital Capacities
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html

In [6]:
Capacity_Table= pd.read_csv('/home/jovyan/demo/Hospital_Capacity.csv')

Results¶

Table 1. Savannah Venues

In [19]:
Savannah_data=A_neighborhoods_venues_sorted
Savannah_data
Out[19]:
Neighborhood 1st Most Common Venue 2nd Most Common Venue 3rd Most Common Venue 4th Most Common Venue 5th Most Common Venue 6th Most Common Venue 7th Most Common Venue 8th Most Common Venue 9th Most Common Venue 10th Most Common Venue
0 Avalon Mobile Phone Shop Pizza Place Chinese Restaurant Sandwich Place Mexican Restaurant Restaurant Big Box Store Breakfast Spot Fast Food Restaurant Hardware Store
1 Avondale Park Sporting Goods Shop General Travel Convenience Store Historic Site Seafood Restaurant Skating Rink Fast Food Restaurant Food Liquor Store
2 Baldwin Park Gas Station Park Intersection Playground American Restaurant Southern / Soul Food Restaurant Salon / Barbershop Sporting Goods Shop Liquor Store Lounge
3 Bartow Pet Store Park Discount Store Food Business Service Seafood Restaurant Chinese Restaurant Grocery Store Mobile Phone Shop American Restaurant
4 Bayview Garden Kids Store Drive-in Theater Women's Store Donut Shop Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant
5 Beach Institute Plaza Bed & Breakfast Park Southern / Soul Food Restaurant Hotel Italian Restaurant Dive Bar Bakery Tea Room BBQ Joint
6 Berkshire Woods Park Home Service Photography Studio Coffee Shop Donut Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market
7 Bingville Convenience Store Park Discount Store Wings Joint Grocery Store General Entertainment Fast Food Restaurant Mexican Restaurant Electronics Store Bar
8 Blueberry Hill Farm Women's Store Wings Joint Food Truck Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market
9 Brookview Chinese Restaurant Intersection Construction & Landscaping Food Furniture / Home Store Golf Course Food & Drink Shop Thrift / Vintage Store Southern / Soul Food Restaurant Electronics Store
10 Cann Park Bakery Chinese Restaurant Seafood Restaurant Mobile Phone Shop Discount Store Intersection Park Massage Studio Salon / Barbershop Gym / Fitness Center
11 Carver Heights Coffee Shop American Restaurant Seafood Restaurant Park Café Restaurant Pub Spa Brewery Burger Joint
12 Chatham Crescent Café Seafood Restaurant American Restaurant Antique Shop Coffee Shop Southern / Soul Food Restaurant Gas Station Playground Plaza Spa
13 Chatham Parkway Sandwich Place Pharmacy Breakfast Spot Fast Food Restaurant Gym Gun Range Italian Restaurant Japanese Restaurant Women's Store Flower Shop
14 Chippewa Cosmetics Shop Lingerie Store Department Store Furniture / Home Store Mexican Restaurant Smoothie Shop Restaurant Coffee Shop Deli / Bodega Mobile Phone Shop
15 Cloverdale Park Moving Target Road Intersection Women's Store Donut Shop Food Flower Shop Fish Market Fast Food Restaurant
16 Coffee Bluff Photography Studio Harbor / Marina Women's Store Dog Run Food Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
17 Colonial Oaks Home Service Photography Studio Coffee Shop Park Donut Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market
18 Colonial Village Home Service Photography Studio Coffee Shop Park Donut Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market
19 Dawes Avenue Discount Store Sandwich Place Bakery Construction & Landscaping Deli / Bodega Brewery Grocery Store Food Flower Shop Fish Market
20 Dixon Park Coffee Shop American Restaurant BBQ Joint Restaurant Park Historic Site Farmers Market Middle Eastern Restaurant New American Restaurant Italian Restaurant
21 Downtown Savannah Plaza Bistro Southern / Soul Food Restaurant History Museum Australian Restaurant Museum Pub Lounge French Restaurant Bookstore
22 East Savannah Pizza Place Discount Store Grocery Store Ice Cream Shop Supermarket Sandwich Place BBQ Joint Construction & Landscaping Department Store Drive-in Theater
23 Eastside Park Coffee Shop Sandwich Place Chinese Restaurant Pizza Place Home Service Ice Cream Shop Big Box Store Fried Chicken Joint Discount Store
24 Edgemere Park Baseball Field Pharmacy Convenience Store Pool Tennis Court Salon / Barbershop Dog Run Coffee Shop Plaza
25 Fairfield Pharmacy Sandwich Place Convenience Store Café Gas Station Pizza Place Fast Food Restaurant Dessert Shop Supplement Shop Tanning Salon
26 Fairway Oaks Pharmacy Fast Food Restaurant Hospital Intersection Pizza Place Dessert Shop Caribbean Restaurant Café Burrito Place Sandwich Place
27 Fernwood Discount Store Sports Bar Convenience Store American Restaurant Donut Shop Fast Food Restaurant Market Shopping Mall Seafood Restaurant Sandwich Place
28 Forest Park Candy Store Southern / Soul Food Restaurant Lounge Gourmet Shop Hotel Plaza Park New American Restaurant Seafood Restaurant Boutique
29 Forest Ridge Candy Store Southern / Soul Food Restaurant Lounge Gourmet Shop Hotel Plaza Park New American Restaurant Seafood Restaurant Boutique
30 Habersham Woods Hotel Coffee Shop Grocery Store Women's Store Sandwich Place Market Shopping Plaza Burger Joint Seafood Restaurant Men's Store
31 Highland Park Asian Restaurant Sandwich Place American Restaurant Multiplex Sushi Restaurant Ice Cream Shop Pizza Place Massage Studio Southern / Soul Food Restaurant Spa
32 Hillcrest Discount Store Gym Costume Shop Indian Restaurant Seafood Restaurant Fried Chicken Joint Sports Bar Supermarket BBQ Joint Intersection
33 Hitch Village Plaza Coffee Shop Bookstore Bistro Tea Room Diner Cocktail Bar Museum Dive Bar Pub
34 Jackson Park BBQ Joint River Women's Store Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
35 Kayton Plaza Coffee Shop Museum Fried Chicken Joint Bed & Breakfast Bar Bakery Playground Pub Farmers Market
36 Kensington Park Hotel Café Pharmacy Grocery Store Southern / Soul Food Restaurant Market Breakfast Spot Seafood Restaurant Sandwich Place Salon / Barbershop
37 Laurel Grove Park Fried Chicken Joint Bakery Mobile Phone Shop Intersection Seafood Restaurant Women's Store Drive-in Theater Flower Shop Fish Market
38 Live Oak Convenience Store Shipping Store Cosmetics Shop Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
39 Mayfair Bakery Lake Kids Store Bar Park Baseball Field Bike Rental / Bike Share Pool Thrift / Vintage Store Track
40 Medical Arts Sandwich Place Pharmacy Pizza Place Café Coffee Shop Hospital Food & Drink Shop Smoothie Shop Shopping Plaza Medical Center
41 Metropolitan Bus Station Nightclub Food Playground Soccer Field Seafood Restaurant Food Truck Soccer Stadium Metro Station Sandwich Place
42 Oakdale Pharmacy Cosmetics Shop Video Store Gas Station Deli / Bodega Pizza Place Dessert Shop Multiplex Mexican Restaurant Salon / Barbershop
43 Oakhurst Sandwich Place Discount Store Bakery Shopping Mall Liquor Store Smoothie Shop Lingerie Store Electronics Store Korean Restaurant Rental Car Location
44 Oakland Park Discount Store American Restaurant Clothing Store Coffee Shop Seafood Restaurant Sandwich Place Liquor Store Sports Bar Rental Car Location Big Box Store
45 Oglethorpe Plaza Bistro Southern / Soul Food Restaurant Dessert Shop Coffee Shop Museum Bar Cosmetics Shop New American Restaurant Pub
46 Paradise Park Korean Restaurant Historic Site Bakery Park Chinese Restaurant Fast Food Restaurant Cosmetics Shop Café Pet Service ATM
47 Parkside Golf Course Brewery Business Service Gas Station Liquor Store Locksmith Chinese Restaurant Sandwich Place Grocery Store IT Services
48 Pine Gardens Convenience Store Clothing Store Building Furniture / Home Store Liquor Store Seafood Restaurant Bar Discount Store Golf Course Park
49 Poplar Place Baseball Field Scenic Lookout Donut Shop Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
50 Ridgewood American Restaurant Café Sandwich Place Pizza Place Pharmacy Hospital Japanese Restaurant Smoothie Shop Shopping Plaza Pet Store
51 Rivers End Playground Intersection Fast Food Restaurant Cosmetics Shop Convenience Store Cupcake Shop Drive-in Theater Food & Drink Shop Food Flower Shop
52 Rose Dhu Campground Women's Store Drive-in Theater Food Truck Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant Farmers Market
53 Savannah Gardens Convenience Store Park Liquor Store Bar Seafood Restaurant Golf Course Dessert Shop Department Store Food Flower Shop
54 Savannah State University Harbor / Marina Seafood Restaurant American Restaurant Sporting Goods Shop Women's Store Drive-in Theater Food & Drink Shop Food Flower Shop Fish Market
55 Shirley Park Chinese Restaurant Shopping Mall Gas Station Seafood Restaurant Discount Store Intersection Supermarket Dessert Shop Food Sports Bar
56 South Garden Candy Store Southern / Soul Food Restaurant Lounge Gourmet Shop Hotel Plaza Park New American Restaurant Seafood Restaurant Boutique
57 Southover Brewery Discount Store Vegetarian / Vegan Restaurant Bakery Women's Store Electronics Store Food & Drink Shop Food Flower Shop Fish Market
58 Sunset Park Sports Bar Fried Chicken Joint Fast Food Restaurant Coffee Shop Pharmacy Pizza Place Discount Store Thai Restaurant Big Box Store Donut Shop
59 Sylvan Terrace Harbor / Marina Boat or Ferry Scenic Lookout Women's Store Donut Shop Food & Drink Shop Food Flower Shop Fish Market Fast Food Restaurant
60 Thomas Square Gourmet Shop Pharmacy Pub River Dive Bar Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
61 Tremont Park Gas Station Discount Store Convenience Store Intersection Food Fast Food Restaurant Grocery Store Construction & Landscaping Deli / Bodega Wine Bar
62 Victory Heights Chinese Restaurant Mobile Phone Shop Fast Food Restaurant Pizza Place Coffee Shop Pharmacy Big Box Store Restaurant Mexican Restaurant Fried Chicken Joint
63 Victory Manor Pizza Place Coffee Shop Chinese Restaurant Mexican Restaurant Sandwich Place Hardware Store Donut Shop Big Box Store Breakfast Spot Fast Food Restaurant
64 Victory Square Chinese Restaurant Mobile Phone Shop Fast Food Restaurant Pizza Place Coffee Shop Pharmacy Big Box Store Restaurant Mexican Restaurant Fried Chicken Joint
65 West Savannah Pizza Place Discount Store Grocery Store Ice Cream Shop Supermarket Sandwich Place BBQ Joint Construction & Landscaping Department Store Drive-in Theater
66 Windsor Forest Pizza Place Intersection Convenience Store Sandwich Place Fast Food Restaurant Building Mediterranean Restaurant Storage Facility Gas Station BBQ Joint
67 Winter Gardens Pool Soccer Field Video Game Store Women's Store Dog Run Flower Shop Fish Market Fast Food Restaurant Farmers Market Farm
68 Yamacraw Village Museum Plaza Dessert Shop Hotel Tourist Information Center Lounge Market Brewery Restaurant Diner

Table 2. Jacksonville Venues

In [19]:
Jacksonville_data=A_neighborhoods_venues_sorted
Jacksonville_data
Out[19]:
Neighborhood 1st Most Common Venue 2nd Most Common Venue 3rd Most Common Venue 4th Most Common Venue 5th Most Common Venue 6th Most Common Venue 7th Most Common Venue 8th Most Common Venue 9th Most Common Venue 10th Most Common Venue
0 Arlington Video Store Restaurant ATM Italian Restaurant Mexican Restaurant Shopping Mall Seafood Restaurant Sandwich Place Fried Chicken Joint Bookstore
1 Avondale Park Pizza Place Convenience Store Gaming Cafe Plaza Deli / Bodega New American Restaurant Coffee Shop Chinese Restaurant Smoke Shop
2 Belfort Station Hotel Sandwich Place Automotive Shop Cocktail Bar Chinese Restaurant Food Truck Gas Station Japanese Restaurant Italian Restaurant Mexican Restaurant
3 Brooklyn Café Park Deli / Bodega Gym / Fitness Center Gym Smoothie Shop Sandwich Place Concert Hall Plaza Playground
4 Church District Grocery Store Pizza Place Japanese Restaurant Intersection Spa Shopping Mall Pharmacy Liquor Store Shipping Store Sandwich Place
5 Downtown Bakery History Museum Truck Stop Gas Station Bar Italian Restaurant Greek Restaurant Rest Area American Restaurant Dive Bar
6 East Jacksonville Fast Food Restaurant Video Store Light Rail Station Train Station Sandwich Place Bakery Zoo Event Service Flea Market Farmers Market
7 Empire Point Chiropractor Lawyer American Restaurant Rental Car Location Gas Station Baseball Field Donut Shop Flea Market Fast Food Restaurant Farmers Market
8 Mandarin Event Service Pet Store Business Service Farmers Market Park Food Truck Flea Market Fast Food Restaurant Exhibit Zoo
9 North Jacksonville Fast Food Restaurant Video Store Light Rail Station Train Station Sandwich Place Bakery Zoo Event Service Flea Market Farmers Market
10 Oakland Bar Rental Car Location Park Italian Restaurant Café Flea Market Burrito Place Food Truck Soccer Stadium Brewery
11 Ortega Park Harbor / Marina Home Service Jewelry Store Pharmacy Flower Shop Garden Center Bank Diner Trail
12 River Park Coffee Shop Art Gallery Café Mexican Restaurant Food Truck Brewery Burrito Place Sandwich Place Lounge Comfort Food Restaurant
13 Riverside American Restaurant Sushi Restaurant Sandwich Place Restaurant Bar Coffee Shop Record Shop Cosmetics Shop Smoothie Shop Cocktail Bar
14 San Marco Coffee Shop American Restaurant Mediterranean Restaurant Sandwich Place Brewery Restaurant Speakeasy Diner Café Mexican Restaurant
15 Sherwood Forest Music Venue Discount Store Zoo Exhibit Food Truck Flower Shop Flea Market Fast Food Restaurant Farmers Market Event Service
16 South Jacksonville Hotel Mediterranean Restaurant Mexican Restaurant Coffee Shop Sandwich Place Resort Sports Bar Café Cocktail Bar Pizza Place
17 South Side Park Pizza Place Baseball Field Salon / Barbershop Photography Studio Disc Golf Donut Shop Shipping Store Chinese Restaurant Music Venue
18 Springfield Zoo Exhibit Flower Shop Tea Room Deli / Bodega Discount Store Dive Bar Dog Run Donut Shop French Restaurant
19 Stadium District Stadium American Restaurant Fast Food Restaurant Pizza Place Pet Store Coffee Shop General Entertainment Burger Joint Shipping Store Juice Bar
20 Waterleaf Food Truck Intersection Photography Studio Disc Golf Discount Store Diner Dive Bar Dog Run French Restaurant Donut Shop
21 West Jacksonville Home Service Cosmetics Shop Middle Eastern Restaurant Intersection Sandwich Place Cafeteria Caribbean Restaurant Zoo Farmers Market Flea Market
In [17]:
County_Table
Out[17]:
Unnamed: 0 Duval (DU) , FL Chatham (CA) , GA
0 Demographics
1 Population 950,181 289,195
2 % below 18 years of age 22.60% 21.20%
3 % 65 and older 14.00% 15.40%
4 % Non-Hispanic Black 29.50% 40.10%
5 % American Indian & Alaska Native 0.50% 0.40%
6 % Asian 5.10% 2.90%
7 % Native Hawaiian/Other Pacific Islander 0.10% 0.10%
8 % Hispanic 10.10% 6.60%
9 % Non-Hispanic White 52.60% 48.20%
10 % not proficient in English 3% 1%
11 % Females 51.50% 51.90%
12 % Rural 2.90% 4.50%
13 Length of Life
14 Life expectancy 76.2 77.9
15 Premature age-adjusted mortality 440 400
16 Child mortality 80 80
17 Infant mortality 9 7
18 Quality of Life
19 Frequent physical distress 13% 11%
20 Frequent mental distress 13% 12%
21 Diabetes prevalence 12% 10%
22 HIV prevalence 761 702
23 Health Behaviors
24 Food insecurity 18% 17%
25 Limited access to healthy foods 9% 7%
26 Drug overdose deaths 41 13
27 Motor vehicle crash deaths 15 12
28 Insufficient sleep 37% 38%
29 Clinical Care
... ... ... ...
46 Traffic volume 422 362
47 Homeownership 57% 54%
48 Severe housing cost burden 16% 17%
49 Health Outcomes
50 Length of Life
51 Premature death 9,700 8,300
52 Quality of Life
53 Poor or fair health 19% 18%
54 Poor physical health days 4.3 3.4
55 Poor mental health days 4.3 3.7
56 Low birthweight 10% 10%
57 Health Factors
58 Health Behaviors
59 Adult smoking 20% 17%
60 Adult obesity 31% 32%
61 Food environment index 6.6 6.9
62 Physical inactivity 26% 26%
63 Access to exercise opportunities 92% 90%
64 Excessive drinking 19% 17%
65 Alcohol-impaired driving deaths 29% 21%
66 Sexually transmitted infections 738.3 876.8
67 Teen births 29 25
68 Clinical Care
69 Uninsured 13% 16%
70 Primary care physicians 1,160:1 1,130:1
71 Dentists 1,220:1 1,500:1
72 Mental health providers 510:01:00 690:01:00
73 Preventable hospital stays 5,911 4,502
74 Mammography screening 41% 47%
75 Flu vaccinations 43% 45%

76 rows × 3 columns

In [8]:
Death_by_Age_Table
Out[8]:
AGE Number of Deaths Share of deaths With underlying conditions Without underlying conditions Unknown if with underlying cond. Share of deaths of unknown + w/o cond.
0 0 - 17 years old 9 0.06% 6 3 0 0.02%
1 18 - 44 years old 601 3.90% 476 17 108 0.80%
2 45 - 64 years old 3,413 22.40% 2,851 72 490 3.70%
3 65 - 74 years old 3,788 24.90% 2,801 5 982 6.50%
4 75+ years old 7,419 48.70% 5,236 2 2,181 14.30%
5 TOTAL 15,230 100% 11,370 (75%) 99 (0.7%) 1,551 (24.7%) 25.30%

Table 5. Capacity and Fatality Rates
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html

In [12]:
Capacity_Table 
Out[12]:
Description Duval Chatham Queens
0 Number of Beds 3,456 1,569 3,210
1 Cases per 100,000 128 119 2,521
2 Confirmed Cases 1,215 344 57,459
3 Deaths 32 14 4,595
4 Fatality Rate 2.6% 4% 8%

For all rates by county go to: Capacity

Discussion¶

Based on venues in Savannah(Table 1) and Jacksonville(Table 2) there are many businesses/venues that will be significantly impacted by economic shutdown. In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues while in Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues. With so many businesses impacted will reopening be risky? If we take a look at county health rankings(Table 3), only 14-15% of the population is 65 and over indicating a small high-risk population(Table 4) with about 75% of deaths occurring in people 65+. Additionally, access to exercise opportunities are about 90% indicating the ability for most of the population to engage in immune and health boosting activities which is important to improve the obesity rate at 31%. However, we do need to factor in smoking at 20% which increases the risk for complications for Coronavirus. Is there medical capacity for handling increase in cases? According to Johns Hopkins University, capacity and fatality rates(Table 5), Duval and Chatham counties fall well below the averages of Queens, New York. Although New York was initial site, at this point Jacksonville and Savannah have relatively low numbers of infections with a significant number of beds available.

Conclusion¶

The governors of Jacksonville and Savannah should consider the pros and cons of opening up too soon. As Table 5 indicates, the rate of infections and fatalities are relatively low especially for Duval county of Jacksonville. Chatham county has a higher rate but still half of Queens, New York which is the epicenter of the virus. With a population of about 300K, Chatham may fare better than other counties because of the relatively small population and vulnerable population at approximately 15%(65+). Governors have considered opening places at 25% capacity but many businesses can't be profitable at such low capacity. Another suggestion is perhaps sustain stay-at-home orders for vulnerable populations. Businesses like gyms may significantly lower the risks by permitting those under 65 at full capacity with significant cleaning measures. For schools, the most vulnerable populations continue to work online while the least can go back to the classroom. Allow the least vulnerable populations to get back to work and subsidize the ones that need to stay at home.

Appendix¶

All Savannah Neighborhoods¶

In [20]:
neighborhoods
Out[20]:
City Neighborhood Latitude Longitude
0 Savannah Avalon 32.050010 -81.066843
1 Savannah Avondale 32.052988 -81.057612
2 Savannah Baldwin Park 32.050870 -81.091097
3 Savannah Bartow 32.086596 -81.124556
4 Savannah Bayview 30.224534 -85.682356
5 Savannah Beach Institute 32.068951 -81.089268
6 Savannah Berkshire Woods 31.961601 -81.153999
7 Savannah Bingville 32.046542 -81.109500
8 Savannah Blueberry Hill 32.344312 -80.886251
9 Savannah Brookview 32.004379 -81.074279
10 Savannah Cann Park 32.053430 -81.113216
11 Savannah Carver Heights 32.060826 -81.099685
12 Savannah Chatham Crescent 32.050783 -81.096504
13 Savannah Chatham Parkway 32.062359 -81.160074
14 Savannah Chippewa 31.998822 -81.116223
15 Savannah Cloverdale 32.066874 -81.129001
16 Savannah Coffee Bluff 31.936879 -81.153165
17 Savannah Colonial Oaks 31.962156 -81.148444
18 Savannah Colonial Village 31.962156 -81.148444
19 Savannah Dawes Avenue 32.055294 -81.126188
20 Savannah Dixon Park 32.060809 -81.090965
21 Savannah Downtown Savannah 32.075275 -81.098580
22 Savannah East Savannah 39.941368 -94.829946
23 Savannah Eastside 32.046452 -81.066779
24 Savannah Edgemere 32.039377 -81.087612
25 Savannah Fairfield 32.032710 -81.090667
26 Savannah Fairway Oaks 32.019933 -81.095945
27 Savannah Fernwood 32.032155 -81.064279
28 Savannah Forest Park 32.080926 -81.091177
29 Savannah Forest Ridge 32.080926 -81.091177
30 Savannah Habersham Woods 32.019655 -81.107056
31 Savannah Highland Park 32.009656 -81.100390
32 Savannah Hillcrest 37.727200 -84.269892
33 Savannah Hitch Village 32.073000 -81.094000
34 Savannah Jackson Park 35.309266 -83.259593
35 Savannah Kayton 32.069785 -81.104518
36 Savannah Kensington Park 32.023544 -81.101779
37 Savannah Laurel Grove 32.063056 -81.111917
38 Savannah Live Oak 32.083880 -81.195388
39 Savannah Mayfair 31.992990 -81.094278
40 Savannah Medical Arts 32.031369 -81.094137
41 Savannah Metropolitan -33.451491 -70.731706
42 Savannah Oakdale 32.017989 -81.100390
43 Savannah Oakhurst 31.995489 -81.124001
44 Savannah Oakland Park 32.034933 -81.075390
45 Savannah Oglethorpe 32.076763 -81.096973
46 Savannah Paradise Park 33.713487 -117.766140
47 Savannah Parkside 32.274694 -80.926254
48 Savannah Pine Gardens 32.066320 -81.060112
49 Savannah Poplar Place 35.238418 -88.244227
50 Savannah Ridgewood 32.033543 -81.098445
51 Savannah Rivers End 31.986878 -81.115389
52 Savannah Rose Dhu 31.927992 -81.133720
53 Savannah Savannah Gardens 32.061321 -81.060945
54 Savannah Savannah State University 32.022924 -81.056107
55 Savannah Shirley Park 32.024100 -81.079279
56 Savannah South Garden 32.080926 -81.091177
57 Savannah Southover 32.046875 -81.127056
58 Savannah Sunset Park 32.034933 -81.065945
59 Savannah Sylvan Terrace 32.019657 -81.042890
60 Savannah Thomas Square 31.816875 -81.358855
61 Savannah Tremont Park 32.059930 -81.137890
62 Savannah Victory Heights 32.042155 -81.061779
63 Savannah Victory Manor 32.045460 -81.072134
64 Savannah Victory Square 32.042155 -81.061779
65 Savannah West Savannah 39.941368 -94.829946
66 Savannah Windsor Forest 31.976601 -81.132333
67 Savannah Winter Gardens 32.174785 -81.245293
68 Savannah Yamacraw Village 32.081612 -81.100310

All Jacksonville Neighborhoods¶

In [9]:
neighborhoods
Out[9]:
City Neighborhood Latitude Longitude
0 Jacksonville Arlington 30.335795 -81.602871
1 Jacksonville Avondale 30.304406 -81.711209
2 Jacksonville Belfort Station 30.251119 -81.584455
3 Jacksonville Brooklyn 30.323573 -81.674541
4 Jacksonville Church District 30.280525 -81.490998
5 Jacksonville Downtown 30.326066 -81.656353
6 Jacksonville East Jacksonville 30.365447 -81.723926
7 Jacksonville Empire Point 30.313700 -81.615915
8 Jacksonville Mandarin 30.160519 -81.659260
9 Jacksonville North Jacksonville 30.365447 -81.723926
10 Jacksonville Oakland 30.331445 -81.647625
11 Jacksonville Ortega 30.270517 -81.708152
12 Jacksonville River Park 30.332184 -81.655651
13 Jacksonville Riverside 30.312184 -81.684263
14 Jacksonville San Marco 30.304562 -81.650829
15 Jacksonville Sherwood Forest 30.409961 -81.724266
16 Jacksonville South Jacksonville 30.311073 -81.645650
17 Jacksonville South Side 30.369820 -81.506404
18 Jacksonville Springfield 40.050389 -74.763495
19 Jacksonville Stadium District 30.275187 -81.511868
20 Jacksonville Waterleaf 30.336679 -81.492715
21 Jacksonville West Jacksonville 30.340239 -81.722321

Savannah Venue Frequency¶

In [38]:
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')
----Avalon----
                  venue  freq
0    Chinese Restaurant  0.07
1           Pizza Place  0.07
2    Mexican Restaurant  0.07
3     Mobile Phone Shop  0.07
4        Sandwich Place  0.07
5   Fried Chicken Joint  0.03
6  Gym / Fitness Center  0.03
7         Grocery Store  0.03
8      Greek Restaurant  0.03
9         Deli / Bodega  0.03


----Avondale----
                  venue  freq
0                  Food  0.14
1                  Park  0.14
2          Intersection  0.07
3         Historic Site  0.07
4        General Travel  0.07
5          Skating Rink  0.07
6    Seafood Restaurant  0.07
7          Liquor Store  0.07
8         Tour Provider  0.07
9  Fast Food Restaurant  0.07


----Baldwin Park----
                             venue  freq
0                      Gas Station  0.10
1                             Park  0.10
2                     Intersection  0.07
3  Southern / Soul Food Restaurant  0.07
4              American Restaurant  0.07
5                       Playground  0.07
6                     Antique Shop  0.03
7                      Coffee Shop  0.03
8              Sporting Goods Shop  0.03
9        Middle Eastern Restaurant  0.03


----Bartow----
                   venue  freq
0         Discount Store   0.2
1              Pet Store   0.2
2     Seafood Restaurant   0.1
3    American Restaurant   0.1
4                   Park   0.1
5     Chinese Restaurant   0.1
6          Grocery Store   0.1
7         Shipping Store   0.1
8  Outdoors & Recreation   0.0
9          Moving Target   0.0


----Bayview----
                        venue  freq
0                      Garden  0.25
1  Construction & Landscaping  0.25
2                  Kids Store  0.25
3            Drive-in Theater  0.25
4                 Pizza Place  0.00
5       Outdoors & Recreation  0.00
6           Mobile Phone Shop  0.00
7               Moving Target  0.00
8                   Multiplex  0.00
9                      Museum  0.00


----Beach Institute----
                venue  freq
0               Plaza  0.23
1                Park  0.07
2     Bed & Breakfast  0.07
3  Italian Restaurant  0.03
4      Farmers Market  0.03
5              Museum  0.03
6      Breakfast Spot  0.03
7            Fountain  0.03
8            Tea Room  0.03
9      History Museum  0.03


----Berkshire Woods----
                       venue  freq
0                       Park   0.4
1               Home Service   0.2
2         Photography Studio   0.2
3                Coffee Shop   0.2
4                Yoga Studio   0.0
5               Optical Shop   0.0
6  Middle Eastern Restaurant   0.0
7          Mobile Phone Shop   0.0
8              Moving Target   0.0
9                  Multiplex   0.0


----Bingville----
                   venue  freq
0      Convenience Store  0.13
1                   Park  0.13
2         Discount Store  0.09
3                    Bar  0.04
4      Electronics Store  0.04
5   Fast Food Restaurant  0.04
6     Seafood Restaurant  0.04
7            Coffee Shop  0.04
8     Chinese Restaurant  0.04
9  Outdoors & Recreation  0.04


----Blueberry Hill----
                       venue  freq
0                       Farm   1.0
1                Yoga Studio   0.0
2                IT Services   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Brookview----
                             venue  freq
0                     Intersection  0.18
1               Chinese Restaurant  0.18
2           Thrift / Vintage Store  0.09
3  Southern / Soul Food Restaurant  0.09
4           Furniture / Home Store  0.09
5                      Golf Course  0.09
6       Construction & Landscaping  0.09
7                Food & Drink Shop  0.09
8                             Food  0.09
9                        Multiplex  0.00


----Cann Park----
                    venue  freq
0                  Bakery  0.10
1            Intersection  0.07
2          Discount Store  0.07
3      Chinese Restaurant  0.07
4      Seafood Restaurant  0.07
5       Convenience Store  0.07
6                    Park  0.07
7                     Bar  0.03
8  Thrift / Vintage Store  0.03
9       Mobile Phone Shop  0.03


----Carver Heights----
                 venue  freq
0          Coffee Shop  0.10
1  American Restaurant  0.07
2           Restaurant  0.07
3   Seafood Restaurant  0.07
4                 Park  0.07
5                 Café  0.07
6          Yoga Studio  0.03
7           Beer Store  0.03
8           Playground  0.03
9       Farmers Market  0.03


----Chatham Crescent----
                       venue  freq
0        American Restaurant  0.07
1               Antique Shop  0.07
2         Seafood Restaurant  0.07
3                       Café  0.07
4  Middle Eastern Restaurant  0.03
5                        Spa  0.03
6                    Brewery  0.03
7                      Plaza  0.03
8               Burger Joint  0.03
9           Greek Restaurant  0.03


----Chatham Parkway----
                  venue  freq
0                   Gym  0.22
1             Gun Range  0.11
2    Italian Restaurant  0.11
3   Japanese Restaurant  0.11
4         Jewelry Store  0.11
5        Breakfast Spot  0.11
6        Sandwich Place  0.11
7  Fast Food Restaurant  0.11
8          Noodle House  0.00
9          Optical Shop  0.00


----Chippewa----
                    venue  freq
0          Cosmetics Shop  0.10
1        Department Store  0.10
2          Lingerie Store  0.10
3  Furniture / Home Store  0.07
4           Deli / Bodega  0.03
5                  Bakery  0.03
6     Fried Chicken Joint  0.03
7       Mobile Phone Shop  0.03
8             Supermarket  0.03
9      Mexican Restaurant  0.03


----Cloverdale----
                        venue  freq
0                        Park  0.33
1                Intersection  0.17
2               Moving Target  0.17
3  Construction & Landscaping  0.17
4                        Road  0.17
5                 Outlet Mall  0.00
6           Mobile Phone Shop  0.00
7                   Multiplex  0.00
8                      Museum  0.00
9     New American Restaurant  0.00


----Coffee Bluff----
                       venue  freq
0                 Playground   0.5
1            Harbor / Marina   0.5
2                Yoga Studio   0.0
3      Outdoors & Recreation   0.0
4  Middle Eastern Restaurant   0.0
5          Mobile Phone Shop   0.0
6              Moving Target   0.0
7                  Multiplex   0.0
8                     Museum   0.0
9    New American Restaurant   0.0


----Colonial Oaks----
                        venue  freq
0                        Park   0.2
1  Construction & Landscaping   0.2
2                Home Service   0.2
3                 Coffee Shop   0.2
4          Photography Studio   0.2
5       Outdoors & Recreation   0.0
6           Mobile Phone Shop   0.0
7               Moving Target   0.0
8                   Multiplex   0.0
9                      Museum   0.0


----Colonial Village----
                        venue  freq
0                        Park   0.2
1  Construction & Landscaping   0.2
2                Home Service   0.2
3                 Coffee Shop   0.2
4          Photography Studio   0.2
5       Outdoors & Recreation   0.0
6           Mobile Phone Shop   0.0
7               Moving Target   0.0
8                   Multiplex   0.0
9                      Museum   0.0


----Dawes Avenue----
                        venue  freq
0              Discount Store  0.33
1               Deli / Bodega  0.11
2                     Brewery  0.11
3  Construction & Landscaping  0.11
4              Sandwich Place  0.11
5               Grocery Store  0.11
6                      Bakery  0.11
7                 Outlet Mall  0.00
8                   Multiplex  0.00
9                      Museum  0.00


----Dixon Park----
                 venue  freq
0          Coffee Shop  0.10
1  American Restaurant  0.07
2           Restaurant  0.07
3                 Park  0.07
4        Historic Site  0.07
5            BBQ Joint  0.07
6          Yoga Studio  0.03
7         Burger Joint  0.03
8           Beer Store  0.03
9           Taco Place  0.03


----Downtown Savannah----
                             venue  freq
0                            Plaza  0.23
1                           Bistro  0.10
2                   History Museum  0.07
3  Southern / Soul Food Restaurant  0.07
4                              Pub  0.03
5                    Tour Provider  0.03
6                           Museum  0.03
7                              Gym  0.03
8                      Coffee Shop  0.03
9                        Bookstore  0.03


----East Savannah----
                           venue  freq
0                 Discount Store  0.25
1                    Supermarket  0.12
2                      BBQ Joint  0.12
3                 Ice Cream Shop  0.12
4                 Sandwich Place  0.12
5                  Grocery Store  0.12
6                    Pizza Place  0.12
7           Kitchen Supply Store  0.00
8  Paper / Office Supplies Store  0.00
9                      Multiplex  0.00


----Eastside----
                  venue  freq
0           Pizza Place  0.07
1                  Park  0.07
2        Sandwich Place  0.07
3           Coffee Shop  0.07
4    Chinese Restaurant  0.07
5        Breakfast Spot  0.03
6     Mobile Phone Shop  0.03
7  Gym / Fitness Center  0.03
8         Grocery Store  0.03
9      Greek Restaurant  0.03


----Edgemere----
                 venue  freq
0                 Park  0.24
1       Baseball Field  0.12
2          Coffee Shop  0.06
3           Playground  0.06
4         Tennis Court  0.06
5               Lawyer  0.06
6      Laundry Service  0.06
7   Salon / Barbershop  0.06
8                Plaza  0.06
9  Sporting Goods Shop  0.06


----Fairfield----
                             venue  freq
0                         Pharmacy  0.13
1                   Sandwich Place  0.10
2                      Gas Station  0.07
3                             Café  0.07
4                      Pizza Place  0.07
5              Japanese Restaurant  0.03
6                    Burrito Place  0.03
7  Southern / Soul Food Restaurant  0.03
8             Caribbean Restaurant  0.03
9                  Supplement Shop  0.03


----Fairway Oaks----
                  venue  freq
0              Pharmacy  0.14
1  Fast Food Restaurant  0.09
2        Breakfast Spot  0.05
3           Gas Station  0.05
4           Pizza Place  0.05
5                  Café  0.05
6  Caribbean Restaurant  0.05
7         Shopping Mall  0.05
8                   Gym  0.05
9         Tanning Salon  0.05


----Fernwood----
                 venue  freq
0       Discount Store  0.10
1    Convenience Store  0.10
2  American Restaurant  0.07
3           Sports Bar  0.07
4          Pizza Place  0.03
5              Theater  0.03
6            Multiplex  0.03
7           Donut Shop  0.03
8        Shopping Mall  0.03
9  Fried Chicken Joint  0.03


----Forest Park----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Forest Ridge----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Habersham Woods----
                    venue  freq
0                   Hotel  0.20
1           Grocery Store  0.07
2             Coffee Shop  0.07
3      Seafood Restaurant  0.03
4             Men's Store  0.03
5            Burger Joint  0.03
6  Furniture / Home Store  0.03
7          Shopping Plaza  0.03
8            Optical Shop  0.03
9           Women's Store  0.03


----Highland Park----
                 venue  freq
0     Asian Restaurant  0.10
1            Multiplex  0.07
2  American Restaurant  0.07
3       Ice Cream Shop  0.07
4       Sandwich Place  0.07
5     Sushi Restaurant  0.07
6                  Spa  0.03
7  Fried Chicken Joint  0.03
8       Massage Studio  0.03
9   Chinese Restaurant  0.03


----Hillcrest----
                 venue  freq
0       Cosmetics Shop  0.09
1         Intersection  0.09
2       Discount Store  0.09
3                  Gym  0.09
4            BBQ Joint  0.05
5           Sports Bar  0.05
6          Supermarket  0.05
7  Fried Chicken Joint  0.05
8   Chinese Restaurant  0.05
9   Seafood Restaurant  0.05


----Hitch Village----
               venue  freq
0              Plaza  0.23
1        Coffee Shop  0.07
2          Bookstore  0.07
3             Bistro  0.07
4  Food & Drink Shop  0.03
5     Breakfast Spot  0.03
6       Cocktail Bar  0.03
7           Tea Room  0.03
8    Bed & Breakfast  0.03
9           Fountain  0.03


----Jackson Park----
                       venue  freq
0                  BBQ Joint   0.5
1                      River   0.5
2                Outlet Mall   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Kayton----
                 venue  freq
0                Plaza  0.10
1               Museum  0.07
2          Coffee Shop  0.07
3  Fried Chicken Joint  0.07
4      Bed & Breakfast  0.07
5                  Bar  0.07
6        Tour Provider  0.03
7          Gaming Cafe  0.03
8           Playground  0.03
9                  Gym  0.03


----Kensington Park----
                             venue  freq
0                            Hotel  0.10
1                             Café  0.07
2                         Pharmacy  0.07
3                    Grocery Store  0.07
4               Salon / Barbershop  0.03
5             Caribbean Restaurant  0.03
6           Furniture / Home Store  0.03
7                     Burger Joint  0.03
8  Southern / Soul Food Restaurant  0.03
9                      Pizza Place  0.03


----Laurel Grove----
                   venue  freq
0    Fried Chicken Joint   0.2
1                   Park   0.2
2                 Bakery   0.2
3      Mobile Phone Shop   0.1
4           Intersection   0.1
5          Auto Workshop   0.1
6     Seafood Restaurant   0.1
7  Outdoors & Recreation   0.0
8          Moving Target   0.0
9              Multiplex   0.0


----Live Oak----
                        venue  freq
0           Convenience Store  0.33
1  Construction & Landscaping  0.33
2                  Hobby Shop  0.33
3                 Yoga Studio  0.00
4                 Outlet Mall  0.00
5           Mobile Phone Shop  0.00
6               Moving Target  0.00
7                   Multiplex  0.00
8                      Museum  0.00
9     New American Restaurant  0.00


----Mayfair----
                      venue  freq
0    Thrift / Vintage Store  0.11
1                Kids Store  0.11
2                      Park  0.11
3                     Track  0.11
4                      Lake  0.11
5            Baseball Field  0.11
6  Bike Rental / Bike Share  0.11
7                      Pool  0.11
8                       Bar  0.11
9   New American Restaurant  0.00


----Medical Arts----
                             venue  freq
0                   Sandwich Place  0.10
1                         Pharmacy  0.10
2                             Café  0.07
3                      Pizza Place  0.07
4                      Coffee Shop  0.07
5                      Yoga Studio  0.03
6  Southern / Soul Food Restaurant  0.03
7                    Smoothie Shop  0.03
8                   Breakfast Spot  0.03
9                      Gas Station  0.03


----Metropolitan----
            venue  freq
0     Bus Station  0.14
1   Metro Station  0.09
2       Nightclub  0.09
3            Food  0.09
4     Pizza Place  0.05
5  Sandwich Place  0.05
6  Soccer Stadium  0.05
7    Soccer Field  0.05
8      Food Truck  0.05
9             Gym  0.05


----Oakdale----
                venue  freq
0            Pharmacy  0.12
1         Video Store  0.08
2       Deli / Bodega  0.04
3       Grocery Store  0.04
4  Mexican Restaurant  0.04
5           Multiplex  0.04
6        Burger Joint  0.04
7         Gas Station  0.04
8       Shopping Mall  0.04
9         Coffee Shop  0.04


----Oakhurst----
                    venue  freq
0          Sandwich Place  0.07
1          Discount Store  0.07
2  Furniture / Home Store  0.03
3             Supermarket  0.03
4        Storage Facility  0.03
5       Electronics Store  0.03
6           Smoothie Shop  0.03
7           Shopping Mall  0.03
8          Clothing Store  0.03
9           Deli / Bodega  0.03


----Oakland Park----
                           venue  freq
0                 Discount Store  0.11
1            American Restaurant  0.07
2                 Clothing Store  0.07
3                     Sports Bar  0.04
4                 Sandwich Place  0.04
5                      Multiplex  0.04
6                  Shopping Mall  0.04
7                     Shoe Store  0.04
8             Chinese Restaurant  0.04
9  Paper / Office Supplies Store  0.04


----Oglethorpe----
                             venue  freq
0                            Plaza  0.20
1                           Bistro  0.10
2                     Dessert Shop  0.07
3                      Coffee Shop  0.07
4                           Museum  0.07
5  Southern / Soul Food Restaurant  0.07
6                     Gourmet Shop  0.03
7                              Bar  0.03
8                   Cosmetics Shop  0.03
9               Persian Restaurant  0.03


----Paradise Park----
                  venue  freq
0                  Park  0.10
1    Chinese Restaurant  0.10
2     Korean Restaurant  0.07
3                Bakery  0.07
4  Fast Food Restaurant  0.07
5     Hotpot Restaurant  0.03
6                  Café  0.03
7        Shipping Store  0.03
8        Cosmetics Shop  0.03
9           Pizza Place  0.03


----Parkside----
                venue  freq
0         Golf Course  0.12
1       Bowling Alley  0.06
2  Salon / Barbershop  0.06
3             Brewery  0.06
4    Business Service  0.06
5      Shopping Plaza  0.06
6       Grocery Store  0.06
7  Chinese Restaurant  0.06
8           Locksmith  0.06
9        Liquor Store  0.06


----Pine Gardens----
                    venue  freq
0          Discount Store  0.08
1                    Park  0.08
2                Building  0.08
3             Golf Course  0.08
4  Furniture / Home Store  0.08
5                     Bar  0.08
6                    Food  0.08
7      Seafood Restaurant  0.08
8            Liquor Store  0.08
9          Clothing Store  0.08


----Poplar Place----
                       venue  freq
0             Baseball Field   1.0
1                Yoga Studio   0.0
2              Metro Station   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Ridgewood----
                             venue  freq
0                      Pizza Place  0.07
1              American Restaurant  0.07
2                             Café  0.07
3                         Pharmacy  0.07
4                   Sandwich Place  0.07
5               Italian Restaurant  0.03
6  Southern / Soul Food Restaurant  0.03
7                    Smoothie Shop  0.03
8                   Shopping Plaza  0.03
9             Caribbean Restaurant  0.03


----Rivers End----
                  venue  freq
0          Intersection  0.29
1        Cosmetics Shop  0.29
2  Fast Food Restaurant  0.14
3            Playground  0.14
4             Bookstore  0.14
5           Yoga Studio  0.00
6     Mobile Phone Shop  0.00
7         Moving Target  0.00
8             Multiplex  0.00
9                Museum  0.00


----Rose Dhu----
                       venue  freq
0                 Campground   1.0
1                Yoga Studio   0.0
2      Outdoors & Recreation   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Savannah Gardens----
                venue  freq
0   Convenience Store  0.22
1                Park  0.22
2         Golf Course  0.11
3  Seafood Restaurant  0.11
4                Food  0.11
5                 Bar  0.11
6        Liquor Store  0.11
7         Yoga Studio  0.00
8        Optical Shop  0.00
9       Moving Target  0.00


----Savannah State University----
                       venue  freq
0            Harbor / Marina   0.4
1         Seafood Restaurant   0.2
2        Sporting Goods Shop   0.2
3        American Restaurant   0.2
4      Outdoors & Recreation   0.0
5  Middle Eastern Restaurant   0.0
6          Mobile Phone Shop   0.0
7              Moving Target   0.0
8                  Multiplex   0.0
9                     Museum   0.0


----Shirley Park----
                venue  freq
0  Chinese Restaurant  0.17
1        Intersection  0.08
2              Bakery  0.08
3      Discount Store  0.08
4                Park  0.08
5  Seafood Restaurant  0.08
6         Gas Station  0.08
7          Sports Bar  0.08
8         Supermarket  0.08
9        Dessert Shop  0.08


----South Garden----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Southover----
                        venue  freq
0                      Bakery  0.25
1                     Brewery  0.25
2              Discount Store  0.25
3  Construction & Landscaping  0.25
4                 Yoga Studio  0.00
5               Moving Target  0.00
6                   Multiplex  0.00
7                      Museum  0.00
8     New American Restaurant  0.00
9                   Nightclub  0.00


----Sunset Park----
                  venue  freq
0            Sports Bar  0.07
1           Pizza Place  0.07
2        Discount Store  0.07
3  Fast Food Restaurant  0.07
4              Pharmacy  0.07
5   Fried Chicken Joint  0.07
6           Coffee Shop  0.07
7    Chinese Restaurant  0.03
8     Mobile Phone Shop  0.03
9        Breakfast Spot  0.03


----Sylvan Terrace----
                       venue  freq
0            Harbor / Marina  0.50
1              Boat or Ferry  0.25
2             Scenic Lookout  0.25
3               Optical Shop  0.00
4         Mexican Restaurant  0.00
5  Middle Eastern Restaurant  0.00
6          Mobile Phone Shop  0.00
7              Moving Target  0.00
8                  Multiplex  0.00
9                     Museum  0.00


----Thomas Square----
                       venue  freq
0                        Pub   0.2
1           Business Service   0.2
2                      River   0.2
3                   Pharmacy   0.2
4               Gourmet Shop   0.2
5  Middle Eastern Restaurant   0.0
6          Mobile Phone Shop   0.0
7              Moving Target   0.0
8                  Multiplex   0.0
9                     Museum   0.0


----Tremont Park----
                        venue  freq
0  Construction & Landscaping  0.15
1                 Gas Station  0.15
2              Discount Store  0.15
3           Convenience Store  0.08
4        Fast Food Restaurant  0.08
5               Grocery Store  0.08
6               Deli / Bodega  0.08
7                    Wine Bar  0.08
8                Intersection  0.08
9                        Food  0.08


----Victory Heights----
                  venue  freq
0           Pizza Place  0.07
1              Pharmacy  0.07
2  Fast Food Restaurant  0.07
3           Coffee Shop  0.07
4     Mobile Phone Shop  0.07
5    Chinese Restaurant  0.07
6        General Travel  0.03
7         Grocery Store  0.03
8            Sports Bar  0.03
9            Donut Shop  0.03


----Victory Manor----
                  venue  freq
0           Pizza Place  0.07
1    Mexican Restaurant  0.07
2        Sandwich Place  0.07
3    Chinese Restaurant  0.07
4           Coffee Shop  0.07
5      Greek Restaurant  0.03
6   Fried Chicken Joint  0.03
7  Gym / Fitness Center  0.03
8         Grocery Store  0.03
9        Breakfast Spot  0.03


----Victory Square----
                  venue  freq
0           Pizza Place  0.07
1              Pharmacy  0.07
2  Fast Food Restaurant  0.07
3           Coffee Shop  0.07
4     Mobile Phone Shop  0.07
5    Chinese Restaurant  0.07
6        General Travel  0.03
7         Grocery Store  0.03
8            Sports Bar  0.03
9            Donut Shop  0.03


----West Savannah----
                           venue  freq
0                 Discount Store  0.25
1                    Supermarket  0.12
2                      BBQ Joint  0.12
3                 Ice Cream Shop  0.12
4                 Sandwich Place  0.12
5                  Grocery Store  0.12
6                    Pizza Place  0.12
7           Kitchen Supply Store  0.00
8  Paper / Office Supplies Store  0.00
9                      Multiplex  0.00


----Windsor Forest----
                      venue  freq
0              Intersection  0.08
1                 BBQ Joint  0.08
2               Pizza Place  0.08
3         Convenience Store  0.08
4            Sandwich Place  0.08
5      Fast Food Restaurant  0.08
6                  Building  0.08
7               Gas Station  0.08
8  Mediterranean Restaurant  0.08
9             Grocery Store  0.08


----Winter Gardens----
                       venue  freq
0                       Pool  0.25
1               Soccer Field  0.25
2           Video Game Store  0.25
3                        Gym  0.25
4               Optical Shop  0.00
5  Middle Eastern Restaurant  0.00
6          Mobile Phone Shop  0.00
7              Moving Target  0.00
8                  Multiplex  0.00
9                     Museum  0.00


----Yamacraw Village----
                             venue  freq
0                           Museum  0.10
1                            Plaza  0.10
2                     Dessert Shop  0.07
3                            Hotel  0.07
4       Tourist Information Center  0.07
5                           Lounge  0.03
6  Southern / Soul Food Restaurant  0.03
7                             Café  0.03
8                          Brewery  0.03
9                     Gourmet Shop  0.03


Jacksonville Venue Frequency¶

In [15]:
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')
----Arlington----
                 venue  freq
0          Video Store  0.09
1                  ATM  0.04
2          Gas Station  0.04
3    Convenience Store  0.04
4       Sandwich Place  0.04
5           Restaurant  0.04
6       Discount Store  0.04
7           Donut Shop  0.04
8  Fried Chicken Joint  0.04
9            Nightclub  0.04


----Avondale----
                venue  freq
0          Smoke Shop  0.08
1         Pizza Place  0.08
2  Mexican Restaurant  0.04
3  Chinese Restaurant  0.04
4         Coffee Shop  0.04
5                Park  0.04
6          Sports Bar  0.04
7         Gaming Cafe  0.04
8             Brewery  0.04
9      Breakfast Spot  0.04


----Belfort Station----
                  venue  freq
0        Sandwich Place  0.11
1           IT Services  0.11
2                 Hotel  0.11
3    Italian Restaurant  0.06
4           Gas Station  0.06
5    Chinese Restaurant  0.06
6          Cocktail Bar  0.06
7    Mexican Restaurant  0.06
8                   Gym  0.06
9  Gym / Fitness Center  0.06


----Brooklyn----
                        venue  freq
0                        Café  0.10
1                        Park  0.07
2               Deli / Bodega  0.07
3               Burrito Place  0.03
4               Smoothie Shop  0.03
5                     Gay Bar  0.03
6  Construction & Landscaping  0.03
7               Grocery Store  0.03
8                Burger Joint  0.03
9                         Gym  0.03


----Church District----
                 venue  freq
0          Pizza Place  0.08
1   Salon / Barbershop  0.08
2  Japanese Restaurant  0.08
3        Grocery Store  0.08
4   Chinese Restaurant  0.04
5        Shopping Mall  0.04
6       Shop & Service  0.04
7       Shipping Store  0.04
8       Sandwich Place  0.04
9           Restaurant  0.04


----Downtown----
                     venue  freq
0              Coffee Shop  0.10
1               Steakhouse  0.07
2              Art Gallery  0.07
3                     Café  0.07
4                   Lounge  0.07
5           Sandwich Place  0.03
6            Burrito Place  0.03
7                Speakeasy  0.03
8  Comfort Food Restaurant  0.03
9             Concert Hall  0.03


----East Jacksonville----
                  venue  freq
0  Fast Food Restaurant  0.38
1           Video Store  0.12
2         Train Station  0.12
3        Sandwich Place  0.12
4    Light Rail Station  0.12
5                Bakery  0.12
6                   ATM  0.00
7             Pet Store  0.00
8             Nightclub  0.00
9  Other Great Outdoors  0.00


----Empire Point----
                 venue  freq
0          Gas Station  0.17
1           Donut Shop  0.17
2  Rental Car Location  0.17
3       Baseball Field  0.17
4               Lawyer  0.17
5  American Restaurant  0.17
6                Plaza  0.00
7           Playground  0.00
8          Pizza Place  0.00
9   Photography Studio  0.00


----Mandarin----
                   venue  freq
0       Business Service  0.29
1      Electronics Store  0.14
2       Volleyball Court  0.14
3             Food Truck  0.14
4                   Park  0.14
5              Pet Store  0.14
6                    ATM  0.00
7   Other Great Outdoors  0.00
8  Outdoors & Recreation  0.00
9               Pharmacy  0.00


----North Jacksonville----
                  venue  freq
0  Fast Food Restaurant  0.38
1           Video Store  0.12
2         Train Station  0.12
3        Sandwich Place  0.12
4    Light Rail Station  0.12
5                Bakery  0.12
6                   ATM  0.00
7             Pet Store  0.00
8             Nightclub  0.00
9  Other Great Outdoors  0.00


----Oakland----
                   venue  freq
0                    Bar  0.10
1    Rental Car Location  0.07
2                   Park  0.07
3      Convenience Store  0.07
4           Tennis Court  0.03
5          Grocery Store  0.03
6  General Entertainment  0.03
7             Sports Bar  0.03
8                   Café  0.03
9          Burrito Place  0.03


----Ortega----
                     venue  freq
0          Harbor / Marina  0.29
1      American Restaurant  0.14
2             Home Service  0.14
3                    Trail  0.14
4                     Park  0.14
5            Jewelry Store  0.14
6                 Pharmacy  0.00
7  New American Restaurant  0.00
8                Nightclub  0.00
9     Other Great Outdoors  0.00


----River Park----
               venue  freq
0        Coffee Shop  0.10
1        Art Gallery  0.07
2               Café  0.07
3       Dessert Shop  0.03
4   Sushi Restaurant  0.03
5         Food Truck  0.03
6            Dog Run  0.03
7                Pub  0.03
8     Sandwich Place  0.03
9  Convenience Store  0.03


----Riverside----
                 venue  freq
0           Restaurant  0.07
1       Sandwich Place  0.07
2  American Restaurant  0.07
3     Sushi Restaurant  0.07
4                  Bar  0.07
5          Coffee Shop  0.07
6        Grocery Store  0.03
7                  Spa  0.03
8           Taco Place  0.03
9                  Gym  0.03


----San Marco----
                      venue  freq
0               Coffee Shop  0.10
1       American Restaurant  0.07
2            Sandwich Place  0.07
3  Mediterranean Restaurant  0.07
4       Indie Movie Theater  0.03
5                      Park  0.03
6                      Café  0.03
7                 Speakeasy  0.03
8       Sporting Goods Shop  0.03
9                Donut Shop  0.03


----Sherwood Forest----
                     venue  freq
0           Discount Store   0.5
1                Gift Shop   0.5
2                      ATM   0.0
3                Pet Store   0.0
4  New American Restaurant   0.0
5                Nightclub   0.0
6     Other Great Outdoors   0.0
7    Outdoors & Recreation   0.0
8                     Park   0.0
9                 Pharmacy   0.0


----South Jacksonville----
                      venue  freq
0                     Hotel  0.07
1               Coffee Shop  0.07
2        Mexican Restaurant  0.07
3            Sandwich Place  0.07
4  Mediterranean Restaurant  0.07
5                   Brewery  0.03
6                      Café  0.03
7                Sports Bar  0.03
8              Cocktail Bar  0.03
9      Gym / Fitness Center  0.03


----South Side----
                 venue  freq
0                 Park  0.14
1   Salon / Barbershop  0.09
2       Baseball Field  0.09
3          Pizza Place  0.09
4  Japanese Restaurant  0.05
5        Grocery Store  0.05
6         Soccer Field  0.05
7            Disc Golf  0.05
8   Chinese Restaurant  0.05
9      Supplement Shop  0.05


----Springfield----
                 venue  freq
0                  Zoo   0.2
1        Auto Workshop   0.2
2              Exhibit   0.2
3             Tea Room   0.2
4        Deli / Bodega   0.2
5   Italian Restaurant   0.0
6  Japanese Restaurant   0.0
7  Rental Car Location   0.0
8          Record Shop   0.0
9                  Pub   0.0


----Stadium District----
                   venue  freq
0            Pizza Place  0.14
1                    ATM  0.07
2                Stadium  0.07
3  Outdoors & Recreation  0.07
4  General Entertainment  0.07
5   Fast Food Restaurant  0.07
6         Baseball Field  0.07
7                    Gym  0.07
8            Coffee Shop  0.07
9         Shipping Store  0.07


----Waterleaf----
                venue  freq
0       Hot Dog Joint  0.17
1        Intersection  0.17
2                Pool  0.17
3  Photography Studio  0.17
4                 Gym  0.17
5           Rest Area  0.17
6  Italian Restaurant  0.00
7           Nightclub  0.00
8         Record Shop  0.00
9                 Pub  0.00


----West Jacksonville----
                        venue  freq
0        Caribbean Restaurant  0.14
1                Intersection  0.14
2                Home Service  0.14
3              Cosmetics Shop  0.14
4              Sandwich Place  0.14
5  Construction & Landscaping  0.14
6                   Cafeteria  0.14
7                         ATM  0.00
8                        Park  0.00
9                   Pet Store  0.00


In [8]:
from IPython.display import Image

In [9]:
Queens=Image(filename='/home/jovyan/demo/JHU_COVID-19_Queens.png') 
Queens
Out[9]:
In [10]:
Duval=Image(filename='/home/jovyan/demo/JHU_COVID-19_Duval.png') 
Duval
Out[10]:
In [11]:
Chatham=Image(filename='/home/jovyan/demo/JHU_COVID-19_Chatham.png') 
Chatham
Out[11]:
In [ ]: